WorkerDiscountGroupRewardDerivationRuleEligibility

Entity Definition

Logical Name : WorkerDiscountGroupRewardDerivationRuleEligibility
Physical Name : CO_EL_EM_DSC_PRDV

Establishes the association between an employee Discount Group and a RewardDerivationRule. The association indicates that the employee group is eligible for a price reduction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RewardDerivationRuleEligibilityID (FK)(PK) A unique identifier for a Price Derivation Rule Eligibility. ID_EL_PRDV Identity integer
EmployeeDiscountGroupID (FK) The identifier for a specific EMPLOYEE DISCOUNT GROUP. ID_GP_EM_DSC Identity integer WorkerDiscountGroup(CO_GP_EM_DSC)
Description Describes the derivation rule for the employee group price discount. DE_EL_EM_PRDV_RU DescriptionShort varchar(255)
ApplyAfterAllMarkdownsFlag A flag to denote whether the EMPLOYEE DISCOUNT is applied after all the ITEM markdowns have been applied. FL_MKD_APLY_AFT Flag integer
CostPlusFlag A flag to denote whether the price of the ITEM to the EMPLOYEE is calculated by adding a dollar amount or percent to the cost price. FL_CST_PLS_EM_DSC Flag integer
EligibilityDescription Describes this employee-group discount eligibility rule. DE_EL_EM_DSC_GP DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
WorkerDiscountGroup may trigger WorkerDiscountGroupRewardDerivationRuleEligibility
RewardEligibilityRule can be a WorkerDiscountGroupRewardDerivationRuleEligibility

Logical Views containing WorkerDiscountGroupRewardDerivationRuleEligibility

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 11100 - Worker - Macro View
Logical 11140 - Worker - Retail Transaction View